Release 10.1A: OpenEdge Data Management:
SQL Reference

SYSDATATYPES

Contains information on each data type supported by the database.

Table 13 provides details of the SYSDATATYPES table.

Table 13: SYSDATATYPES system table 

Column name	Column data type	Column size
autoincr	SMALLINT	2
casesensitive	SMALLINT	2
createparams	VARCHAR	32
datatype	SMALLINT	2
dhtypename	VARCHAR	32
literalprefix	VARCHAR	1
literalsuffix	VARCHAR	1
localtypename	VARCHAR	1
nullable	SMALLINT	2
odbcmoney	SMALLINT	2
searchable	SMALLINT	2
typeprecision	INTEGER	4
unsignedattr	SMALLINT	2